Transforming data:
(before mapping)
Step1
Change the data Category of Admin1 to State Admin2 to County and
Admin 3 to City and Locattion to Places. then
Click Home then click Transform Data
Step2
On Power Query Editor:
Change Admin1 to Region; Admin2 to Zone Amin3 to Sub_zone
Then click at the left corner of Power Query editor Close and
Apply.
Step3
Visual = 3: Choose Filled map on the
visualization
·
Drag the map (Filled
Map) to the upper right corner
Fields Tab:
·
Location: Region
·
Tooltips: Deaths per
Mth/ %Mom/ %YoY
Format Tab
·
General: X Position = 757, Y Position = 91, Width = 515, Height = 310
Step4
·
Data Colors: press Default color = fx
function, Format by = Color scale, based on field = Deaths per Mth, Diverging = On, Minimum = #E6E6E6, Center = #ECC846, Maximum = #000000.
·
Map controls: Auto Zoom = On, Zoom Buttons = On, Lasso button = off, Geocoding culture = Auto
·
Map styles: Theme = Road, Show labels = On
·
Title: On, Title
text = By Region/State, Word wrap = Off, Font Color = #FFFFFF, Background color = #000000, Alignment = Center, Text size = 14,
Font family = Segoe UI
·
Background: On, color = #FFFFFFF, Transparency = 0%
·
Lock aspect = off
·
Border: On, Color = #E6E6E6, Radius =
0
·
Shadow: Off
·
Tooltip = On, Type = Report Page, Page = Auto, Label Text color = #C8C8C8,
Value text color = #EAEAEA, Text size = 9, Font family = Segoe UI, Background
color = #333333, Transparency = 5%
·
Visual header = On, background color = #FFFFFF, Boarder = #FFFFFF, Transparency =
0%, Icon color = #333333, Visual information icon = On, Visual warning icon =
On, Drill on drop down = On, drill up icon = On, Drill down icon = On, Show
next level icon = On, Expand to next level icon = On, Pin icon = On, Focus mode
icon = On, Filter icon = On, See data layout icon = On, More Options icon = On
Step5
·
Legend: Click on image, Select the legend from the file: Minimize the size
of the legend and drag it to the map; Click on text box, background Off; Write
Low and High in the text box; Font size = 10, Font = Segoe UI, Text = Bold;
Drag the text to the legend
Step6
Create New Measure by right clicking All measures
NB: RED = #EC1304
Green = #73B761
Type: the dax formula Indicator MOM =
If([%MOM] < 0,UNICHAR(9660),UNICHAR(9650))
Again, Create New Measure by
right clicking All measures then
Type: Indicator YOY = If([%YOY] < 0, UNICHAR(9660),UNICHAR(9650))
Save by clicking right sign next to X
Next
From Visualization click Card minimize paste it to %MOM
Under Field:
Drag Indicator MOM from All Measure and paste it field
Under Format: General
Under: Data label press function fx; text size in Data label is 27
Step7
Similarly For Indicator YOY:
Create New Measure by right clicking All measures
Type: the dax formula Indicator YOY =
If([%MOM] < 0,UNICHAR(9660),UNICHAR(9650))
Again, Create New Measure by
right clicking All measures then
Type: Indicator Indicator YOY = If([%YOY] <
0,UNICHAR(9660),UNICHAR(9650))
Save by clicking right sign next to X
Next
From Visualization click
Card and minimize and paste it to %YoY
Under Field:
Under: Data label press function fx
Use the following step by step Gif to create the map
For Step1
For Step2
